	package com.datawarehouse;

public class ScriptWareHouse {
	public static String FAIT = "CREATE TABLE IF NOT EXISTS `FAIT`  ("
			+ "`ID_Societe` INT NOT NULL ," + "`ID_Gite` INT NOT NULL ,"
			+ "`ID_Client` INT NOT NULL ," + "`ID_Periode` INT NOT NULL ,"
			+ "`ID_Confort` INT NOT NULL ," + "`ID_Payement` INT NOT NULL)";

	public static String GITE = "CREATE TABLE `gite` ("
			+ "`gite_key` INT NOT NULL AUTO_INCREMENT ,"
			+ "`gite_street` VARCHAR( 50 ) ,"
			+ "`gite_code_postal` VARCHAR( 20 ) ,"
			+ "`gite_town` VARCHAR( 20 ) ,"
			+ "`gite_region` VARCHAR( 50 ) ,"
			+ "`gite_country` VARCHAR( 20 ) ,"
			+ "`firstnam_owner` VARCHAR( 50 ) ,"
			+ "`familynam_owner` VARCHAR( 50 ) ,"
			+ "`dat_start_rentals` DATE,"
			+ "`tel_owner` VARCHAR( 20 ) , `surface` FLOAT, PRIMARY KEY ( `gite_key` ))";

	public static String CLIENT = " CREATE TABLE `Client` (`Client_Key` INT NOT NULL AUTO_INCREMENT ,"
			+ "`FirstName_Client` VARCHAR( 50 ) ,`Famil_Name_Client` VARCHAR( 50 ) ,`Dat_of_birth_Client` DATE,"
			+ "`Sex_Client` ENUM ('F','M')  ,`Situation_Client`   VARCHAR( 50 ) ,`Tel_Client` VARCHAR( 20 ) ,"
			+ "`Email_Client` VARCHAR( 100 ) ,`Fax_Client` VARCHAR( 50 ) ,`Nationality _Client` VARCHAR( 50 ) ,"
			+ "`Country_Client` VARCHAR( 50 ) ,`Town_Client` VARCHAR( 50 ) ,`Postal_Code_Client` VARCHAR( 20 ) ,"
			+ "`Adress-Street_Client` VARCHAR( 100 ) ,`Compagn_Number` INT,PRIMARY KEY ( `Client_Key` ))";

	public static String DATE_RESERVATION = "CREATE TABLE  IF NOT EXISTS  `DateReservation` (`DateReservation_Key` INT NOT NULL AUTO_INCREMENT ,"
			+ "`Saison` VARCHAR( 50 ) ,`Date_Start_Reservation` DATE,`Date_End_Reservation` DATE,`DayStat_of_Week` INT,"
			+ "`DayEnd_of_Week` INT,`DayStart_number_in_Month` INT,`DayEnd_number_in_Month` INT,`DayStart_number_Overall` INT,`DayEnd_number_Overall` INT,"
			+ "`WeekStart_number_in_Year` INT,`WeekEnd_number_in_Year` INT,`WeekStart_number_oveall` INT,`WeekEnd_number_overall` INT,`Month_Start` VARCHAR( 20 ) ,"
			+ "`Month_End` VARCHAR( 20 ) ,`Month_Start_number_overall` INT,`Month_End_number_overall` INT,`Year_Start` INT,`Year_End` INT,PRIMARY KEY ( `DateReservation_Key` ))";

	public static String PAYEMENT = " CREATE TABLE IF NOT EXISTS `payement` ( `Payement_Key` INT NOT NULL AUTO_INCREMENT , `Initial_Price` FLOAT, `Reduction_Per_Cent` FLOAT, `Reduction_Type` VARCHAR( 100 ) ,"
			+ "`Finaly_Price` FLOAT, `Date_Payement` DATE, `Payement_Type` VARCHAR( 100 ) , `Devise` VARCHAR( 200 ) , PRIMARY KEY ( `Payement_Key` ) ) ";


//////////////////////////////////inser /////////////////////////////

/*CREATE TABLE `Style` (
`ID_Style` INT NOT NULL AUTO_INCREMENT ,
`Intitule_Style` VARCHAR( 200 ) ,
`Descriptif_Style` VARCHAR( 5000 ) ,
PRIMARY KEY ( `ID_Style` )
);*/

}


